/*
 Navicat Premium Data Transfer

 Source Server         : 49.235.177.225
 Source Server Type    : MySQL
 Source Server Version : 50649
 Source Host           : 49.235.177.225:3306
 Source Schema         : e-shop

 Target Server Type    : MySQL
 Target Server Version : 50649
 File Encoding         : 65001

 Date: 01/05/2021 22:58:05
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `phone` int(11) DEFAULT NULL,
  `user` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of admin
-- ----------------------------
BEGIN;
INSERT INTO `admin` VALUES (1, '2021-04-25 15:00:10', NULL, 'admin', NULL, 'admin');
COMMIT;

-- ----------------------------
-- Table structure for bbs
-- ----------------------------
DROP TABLE IF EXISTS `bbs`;
CREATE TABLE `bbs` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `consumer_id` int(11) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `shop_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of bbs
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for consumer
-- ----------------------------
DROP TABLE IF EXISTS `consumer`;
CREATE TABLE `consumer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `address` varchar(255) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `salt` varchar(255) DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `signature` varchar(255) DEFAULT NULL,
  `user` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of consumer
-- ----------------------------
BEGIN;
INSERT INTO `consumer` VALUES (9, NULL, '2021-05-01 17:06:43', '123@qq.com', 'aec4235c9cb00ed361d59d8dad3bcde5', '13544551155', '3584311a2b3c4d', NULL, NULL, '123');
INSERT INTO `consumer` VALUES (8, NULL, '2021-05-01 00:59:52', 'vpn8888vpn@163.com', '0499327afbc6c2b705015a91806408d5', '13544551155', '2584311a2b3c4d', NULL, NULL, 'qq');
COMMIT;

-- ----------------------------
-- Table structure for discount
-- ----------------------------
DROP TABLE IF EXISTS `discount`;
CREATE TABLE `discount` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `coupon` float DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `discount` float DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `reduce` float DEFAULT NULL,
  `seckill` float DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of discount
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for enterprise
-- ----------------------------
DROP TABLE IF EXISTS `enterprise`;
CREATE TABLE `enterprise` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `address` varchar(255) DEFAULT NULL,
  `credentials` varchar(255) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `salt` varchar(255) DEFAULT NULL,
  `sex` varchar(255) DEFAULT NULL,
  `shop_id` int(11) DEFAULT NULL,
  `user` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of enterprise
-- ----------------------------
BEGIN;
INSERT INTO `enterprise` VALUES (10, '广药', '', '2021-05-01 12:23:05', 'few_fdw@qq.com', '592a127f2e87037393d51e6c7dc59a90', '13545115', '2085711a2b3c4d', NULL, 9, 'dong');
INSERT INTO `enterprise` VALUES (9, '广州', '58ee3d6d55fbb2fb2c58cc5.jpeg', '2021-04-30 20:12:13', 'vpn8888vpn@163.com', 'd6613ed94793aa2b99b7835fae268243', '13544551155', '2942401a2b3c4d', '男', 8, 'feng');
COMMIT;

-- ----------------------------
-- Table structure for evaluate
-- ----------------------------
DROP TABLE IF EXISTS `evaluate`;
CREATE TABLE `evaluate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `chance` int(11) DEFAULT NULL,
  `consumer_name` varchar(11) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `level` int(11) DEFAULT NULL,
  `shop_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `order_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of evaluate
-- ----------------------------
BEGIN;
INSERT INTO `evaluate` VALUES (5, 0, 'qq', '非常好的一次购物！！！', '2021-05-01 15:16:00', 5, 8, 19, 1207489441);
INSERT INTO `evaluate` VALUES (6, 0, 'qq', '好评！', '2021-05-01 15:17:00', 4, 8, 27, 1220214839);
COMMIT;

-- ----------------------------
-- Table structure for express
-- ----------------------------
DROP TABLE IF EXISTS `express`;
CREATE TABLE `express` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `consumer_id` int(11) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `depart_address` varchar(255) DEFAULT NULL,
  `dest_address` varchar(255) DEFAULT NULL,
  `express_name` varchar(255) DEFAULT NULL,
  `express_number` varchar(255) DEFAULT NULL,
  `order_id` int(11) DEFAULT NULL,
  `shop_id` int(11) DEFAULT NULL,
  `statues` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of express
-- ----------------------------
BEGIN;
INSERT INTO `express` VALUES (2, 8, '2021-05-02 04:28:41', '广州', '', 'zhongtong', '78202234865169', 1207489441, 8, 1);
INSERT INTO `express` VALUES (3, 8, '2021-05-02 04:30:41', '广州', '', 'yunda', '4313927269089', 1220214839, 8, 1);
COMMIT;

-- ----------------------------
-- Table structure for hibernate_sequence
-- ----------------------------
DROP TABLE IF EXISTS `hibernate_sequence`;
CREATE TABLE `hibernate_sequence` (
  `next_val` bigint(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of hibernate_sequence
-- ----------------------------
BEGIN;
INSERT INTO `hibernate_sequence` VALUES (25);
COMMIT;

-- ----------------------------
-- Table structure for message
-- ----------------------------
DROP TABLE IF EXISTS `message`;
CREATE TABLE `message` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(11) DEFAULT NULL,
  `toUser` varchar(11) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `to_user` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of message
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for orders
-- ----------------------------
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `address` varchar(255) DEFAULT NULL,
  `consumer_cancel` int(11) DEFAULT NULL,
  `consumer_id` int(11) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `describes` varchar(255) DEFAULT NULL,
  `number` int(11) DEFAULT NULL,
  `pay_date` datetime DEFAULT NULL,
  `price` float DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `shop_cancel` int(11) DEFAULT NULL,
  `shop_id` int(11) DEFAULT NULL,
  `statues` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of orders
-- ----------------------------
BEGIN;
INSERT INTO `orders` VALUES (1207489441, NULL, NULL, 8, '2021-05-02 04:23:41', '测试测试！！！！！', 1, '2021-05-02 04:24:04', 4999, 19, NULL, 8, 4);
INSERT INTO `orders` VALUES (1249524339, NULL, NULL, 8, '2021-05-02 04:15:39', '测试留言', 1, '2021-05-02 04:17:20', 7199, 23, NULL, 8, 1);
INSERT INTO `orders` VALUES (1219816736, NULL, NULL, 8, '2021-05-01 21:49:36', '', 1, '2021-05-01 21:50:03', 19999, 22, NULL, 8, 1);
COMMIT;

-- ----------------------------
-- Table structure for product
-- ----------------------------
DROP TABLE IF EXISTS `product`;
CREATE TABLE `product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `color` varchar(255) DEFAULT NULL,
  `desc_photo1` varchar(255) DEFAULT NULL,
  `desc_photo2` varchar(255) DEFAULT NULL,
  `desc_photo3` varchar(255) DEFAULT NULL,
  `desc_photo4` varchar(255) DEFAULT NULL,
  `desc_photo5` varchar(255) DEFAULT NULL,
  `describes` varchar(255) DEFAULT NULL,
  `have_discount` int(11) DEFAULT NULL,
  `have_sell` int(11) DEFAULT NULL,
  `kind` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `number` int(11) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `photo1` varchar(255) DEFAULT NULL,
  `photo2` varchar(255) DEFAULT NULL,
  `photo3` varchar(255) DEFAULT NULL,
  `photo4` varchar(255) DEFAULT NULL,
  `price` float DEFAULT NULL,
  `shop_id` int(11) DEFAULT NULL,
  `undercarriage` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of product
-- ----------------------------
BEGIN;
INSERT INTO `product` VALUES (26, '纯手抄', '96.jpg', '97.jpg', '98.jpg', '99.jpg', '100.jpg', '<p>纯手抄金刚经</p>', 0, NULL, '书籍', '心经金刚经大悲咒普门品地藏经佛书经书手抄本全套', 100, '91.jpg', '91.jpg', '93.jpg', '94.jpg', '95.jpg', 9, 8, NULL);
INSERT INTO `product` VALUES (27, '医学口罩', '106.jpg', '107.jpg', '108.jpg', '109.jpg', '110.jpg', '<p>口罩</p>', NULL, NULL, '医疗用品', '医用一次性医疗口罩成人三层医护医生专用单独', 48, '·01.jpg', '102.jpg', '', '', '', 39, 8, NULL);
INSERT INTO `product` VALUES (21, '黑色', '35.jpg', '36.jpg', '37.jpg', '38.jpg', '39.jpg', '<p><span style=\"color: rgb(102, 102, 102); font-family: tahoma, arial, 微软雅黑, sans-serif; font-size: 12px; background-color: rgb(255, 255, 255);\">产品名称：Xiaomi/小米 小米11 青春.</span></p>', 1, NULL, '数码产品', '当天发货[6期免息送碎屏险]Xiaomi/小米 小米11 青春版新品5G全网通小米官方旗舰店官网正品小米手机11青春版', 89, '31.jpg', '32.jpg', '33.jpg', '34.jpg', '', 1999, 8, NULL);
INSERT INTO `product` VALUES (22, '白色', '41.jpg', '42.jpg', '43.jpg', '44.jpg', '', '<p>Huawei/华为 Mate X2内折叠麒麟9000折叠双屏手机MateX2折叠双屏</p>', 1, NULL, '数码产品', 'Huawei/华为 Mate X2内折叠麒麟9000折叠双屏手机MateX2折叠双屏', 97, '45.jpg', '46.jpg', '47.jpg', '', '', 19999, 8, NULL);
INSERT INTO `product` VALUES (25, '现摘现卖', '80.jpg', '76.jpg', '77.jpg', '78.jpg', '79.jpg', '<p>每天享受新鲜<br/></p>', NULL, NULL, '水果', '云南宾川沃柑新鲜水果当季整箱10斤桔橘子沃甘', 100, '71.jpg', '72.jpg', '73.jpg', '74.jpg', '75.jpg', 59, 8, NULL);
INSERT INTO `product` VALUES (23, '银色', '51.jpg', '52.jpg', '53.jpg', '54.jpg', '55.jpg', '<p>2020款苹果笔记本电脑macbookair m1 256G</p>', 1, NULL, '数码产品', '2020款苹果笔记本电脑macbookair m1 13.3英寸D32大学生教育优惠', 78, '56.jpg', '57.jpg', '58.jpg', '59.jpg', '', 7199, 8, NULL);
INSERT INTO `product` VALUES (24, '蓝色', '66.png', '67.png', '68.jpg', '', '', '<p>Nike正品</p>', NULL, NULL, '服装', 'PUMA彪马官方正品 男女同款情侣休闲鞋NIke', 100, '61.jpg', '62.jpg', '', '', '', 399, 8, NULL);
INSERT INTO `product` VALUES (19, '黑色', '17.jpg', '17.jpg', '18.jpg', '', '', '<p>苹果12<br/></p>', 1, NULL, '数码产品', 'Apple/苹果iPhone 12全网通5G手机 原装国行苹果12外包一号店128G', 89, '11.jpg', '12.jpg', '13.jpg', '14.jpg', '15.jpg', 4999, 8, NULL);
INSERT INTO `product` VALUES (28, '纯手工制作', '116.jpg', '117.jpg', '118.jpg', '119.jpg', '120.jpg', '<p>先做现卖蛋糕</p>', NULL, NULL, '食品', '元祖情人节情有独钟水果鲜奶油蛋糕网红情侣创意节日生日', 100, '111.jpg', '112.jpg', '113.jpg', '', '', 19, 8, NULL);
INSERT INTO `product` VALUES (29, '黑色', '126.jpg', '127.jpg', '128.jpg', '129.jpg', '130.jpg', '<p>滇苏帕尔电磁炉</p>', NULL, NULL, '电器', '苏泊尔电磁炉家用智能新款小型节能省电炒菜一体套装', 100, '121.jpg', '122.jpg', '123.jpg', '', '', 129, 8, NULL);
INSERT INTO `product` VALUES (30, '定制', '146.jpg', '147.jpg', '148.jpg', '149.jpg', '150.jpg', '<p>他大学生床上用品全套服务<br/></p>', NULL, NULL, '日常用具', '宿舍纯棉三件套高中学生用单人被子被套床单大学住宿床上用品全套', 100, '141.jpg', '142.jpg', '143.jpg', '', '', 99, 8, NULL);
INSERT INTO `product` VALUES (31, '详情请咨询客服', '166.jpg', '', '', '', '', '<p>王者代练，出号</p>', NULL, NULL, '其他', '低价 王者荣耀手游出租号安卓IOSVX区借号苹果Q区 V8武则天艾琳', 100, '161.jpg', '162.jpg', '', '', '', 1, 8, NULL);
COMMIT;

-- ----------------------------
-- Table structure for product_copy
-- ----------------------------
DROP TABLE IF EXISTS `product_copy`;
CREATE TABLE `product_copy` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `color` varchar(255) DEFAULT NULL,
  `desc_photo1` varchar(255) DEFAULT NULL,
  `desc_photo2` varchar(255) DEFAULT NULL,
  `desc_photo3` varchar(255) DEFAULT NULL,
  `desc_photo4` varchar(255) DEFAULT NULL,
  `desc_photo5` varchar(255) DEFAULT NULL,
  `describes` varchar(255) DEFAULT NULL,
  `have_discount` int(11) DEFAULT NULL,
  `have_sell` int(11) DEFAULT NULL,
  `kind` varchar(255) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  `number` int(11) DEFAULT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `photo1` varchar(255) DEFAULT NULL,
  `photo2` varchar(255) DEFAULT NULL,
  `photo3` varchar(255) DEFAULT NULL,
  `photo4` varchar(255) DEFAULT NULL,
  `price` float DEFAULT NULL,
  `shop_id` int(11) DEFAULT NULL,
  `undercarriage` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of product_copy
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for punish_consumer
-- ----------------------------
DROP TABLE IF EXISTS `punish_consumer`;
CREATE TABLE `punish_consumer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `consumer_id` int(11) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `proof` varchar(255) DEFAULT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `report_email` varchar(255) DEFAULT NULL,
  `serious` int(11) DEFAULT NULL,
  `consumer_name` varchar(255) DEFAULT NULL,
  `statues` int(2) DEFAULT NULL,
  `result` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of punish_consumer
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for punish_enterprise
-- ----------------------------
DROP TABLE IF EXISTS `punish_enterprise`;
CREATE TABLE `punish_enterprise` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `enterprise_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `proof` varchar(255) DEFAULT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `report_email` varchar(255) DEFAULT NULL,
  `serious` int(11) DEFAULT NULL,
  `shop_id` int(11) DEFAULT NULL,
  `shop_Name` varchar(255) DEFAULT NULL,
  `statues` int(2) DEFAULT NULL,
  `result` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of punish_enterprise
-- ----------------------------
BEGIN;
INSERT INTO `punish_enterprise` VALUES (18, '2021-05-01 16:33:00', 0, 0, 'Unknown.jpeg', '{\"orderId\":1220214839,\"reason\":\"假口罩，真的他妈没良心。\",\"type\":\"涉及诈骗\"}', 'fdw_fdw@qq.com', 1, 8, '外包一号店', 1, '同意');
INSERT INTO `punish_enterprise` VALUES (17, '2021-05-01 16:30:00', 0, 0, '58.jpg', '{\"orderId\":1207489441,\"reason\":\"我要举报卖家虚假宣传，说好的苹果12，却给了我一台macbookair m1版本。\",\"type\":\"虚假内容\"}', 'fdw_fdw@qq.com', 0, 8, '外包一号店', NULL, NULL);
COMMIT;

-- ----------------------------
-- Table structure for seckill_order
-- ----------------------------
DROP TABLE IF EXISTS `seckill_order`;
CREATE TABLE `seckill_order` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `consumer_id` int(11) DEFAULT NULL,
  `order_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `shop_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of seckill_order
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for seckill_product
-- ----------------------------
DROP TABLE IF EXISTS `seckill_product`;
CREATE TABLE `seckill_product` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date_end` varchar(255) DEFAULT NULL,
  `date_start` varchar(255) DEFAULT NULL,
  `number` int(11) DEFAULT NULL,
  `number_start` int(11) DEFAULT NULL,
  `price` float DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `version` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=78 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of seckill_product
-- ----------------------------
BEGIN;
INSERT INTO `seckill_product` VALUES (77, '2021-05-26 09:00:00', '2021-05-10 09:00:00', 10, 10, 3999, 19, 0);
INSERT INTO `seckill_product` VALUES (76, '2021-05-16 09:00:00', '2021-04-25 09:00:00', 20, 20, 6199, 23, 0);
INSERT INTO `seckill_product` VALUES (75, '2021-05-26 09:00:00', '2021-04-30 09:00:00', 10, 10, 1999, 21, 0);
INSERT INTO `seckill_product` VALUES (72, '2021-05-11 09:00:00', '2021-05-01 09:00:00', 1, 1, 16666, 22, 0);
COMMIT;

-- ----------------------------
-- Table structure for service
-- ----------------------------
DROP TABLE IF EXISTS `service`;
CREATE TABLE `service` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `consumer_id` int(11) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `order_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `shop` varchar(255) DEFAULT NULL,
  `shop_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of service
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for shop
-- ----------------------------
DROP TABLE IF EXISTS `shop`;
CREATE TABLE `shop` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime DEFAULT NULL,
  `enterprise_id` int(11) DEFAULT NULL,
  `name` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of shop
-- ----------------------------
BEGIN;
INSERT INTO `shop` VALUES (9, '2021-05-01 12:23:05', 10, '广药2号店');
INSERT INTO `shop` VALUES (8, '2021-04-30 20:12:13', 9, '外包一号店');
COMMIT;

-- ----------------------------
-- Table structure for shopping_cart
-- ----------------------------
DROP TABLE IF EXISTS `shopping_cart`;
CREATE TABLE `shopping_cart` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `consumer_id` int(11) DEFAULT NULL,
  `count` int(11) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `shop_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of shopping_cart
-- ----------------------------
BEGIN;
INSERT INTO `shopping_cart` VALUES (8, 8, 1, '2021-05-01 15:40:02', 19, 8);
INSERT INTO `shopping_cart` VALUES (7, 8, 1, '2021-05-01 15:39:54', 23, 8);
INSERT INTO `shopping_cart` VALUES (6, 8, 1, '2021-05-01 15:39:27', 22, 8);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
